Here-> select teamid, teamname from teams2008 where Teamnameshort = "New College Swindon" and sport="Football" limit 1
Note: All fixtures with a pale yellow background are in progress and are not confirmed results.
KO | Home Team | Score | Away Team | Competition | ||
---|---|---|---|---|---|---|
Mon 15 Oct 18 | 19:45 | New College Swindon | 0 - 10 | Melksham Town | ||